package com.ruoyi.biz.letter.mapper;

import java.util.List;

import com.ruoyi.biz.letter.domain.BizMayorHotline;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.biz.report.letter.vo.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 政务服务热线服务Mapper接口
 *
 * @author Fei.Cong
 * @date 2024-07-18
 */
@Mapper
public interface BizMayorHotlineMapper extends BaseMapper<BizMayorHotline> {

    IPage<BizMayorHotline> selectPageList(IPage<BizMayorHotline> page, @Param("entity") BizMayorHotline bizMayorHotline);

    List<ReportCityCategoryResp> selectReportGroupCityAndCategory(@Param("entity") CategoryReportReq reportReq);

    List<ReportYearCityResp> selectReportGroupMonthAndOwnerArea(@Param("entity") CategoryReportReq reportReq);

    List<ReportYearCategoryResp> selectReportGroupMonthAndCategory(@Param("entity") CategoryReportReq reportReq);

    List<CategoryCount> selectReportGroupCategory(@Param("currentMonth") String currentMonth);

}
